﻿use [{0}]
select org.AccessionVersion AccessionVersion, Max(org.Organism) Definition, count(*) GeneCount
from Organism org, Gene g
where org.AccessionVersion = g.AccessionVersion
group by org.AccessionVersion
